Factors affecting intra-relations of backend cost drivers in multi-brand retail domestic super market under convenience stores format: A customer aligned model of supply-chain optimisation framework

 

A.S. Suresh1, Dr. S. Ramesh2

1Associate Professor, Institute of Management, Christ University and Scholar SCSVM University, Kanchipuram.

2Dean, Faculty of Commerce and Management-Pg, Mount Carmel College, Bangalore

*Corresponding Author E-mail: dr.rkmondal@gmail.com, drpsatyanarayana@gmail.com

 

ABSTRACT:

The main focus of this research paper is in the area of organized retail specifically in the convenience stores format in the city of Bangalore and is confined to Grocery, staples and fruits and vegetables business as food contributes to almost 63% in the organized retail business. The study was conducted during June 2014 and December 2015.

The research revealed that there are not many integrated supply chain models aligned to consumer preference, though there are models on different components of supply chain and retail. This study is intended to understand the drivers and factors influencing the back end operations in the area of supply chain efficiencies to create an integrated consumer aligned model frame work to drive optimizations at all levels. This can assist Indian companies in taking strategic decisions and competing in the emerging eco system of E-tailing on one hand and entry of multi nationals on the other.

Sample unit of this study was two major organized retail companies operating in the convenience stores format in Bangalore catering to about seventy outlets and having distribution centres and the same was derived using probabilistic multi stage sample design, from the overall population of urban retailers operating in the convenience stores format.

Primary data was collected through observation schedules for all the key parameters for both back end and front end consumer operations. Multiple Linear regression was used as inferential model, Linear programming for simulation and optimisation.

 

KEY WORDS: Organized retail, convenience stores, FDI, Grocery, fruits and vegetables Supply chain, Business model.

 

 


INTRODUCTION:

The Indian retail industry has experienced tremendous growth over the last decade with a noticeable shift of consumers’ towards organized retailing. Brick and Mortar organized retail is growing rapidly but is still in the nascent stage. There are many challenges in terms of competition from Multinational giants like Wal-Mart, overall value chain and emerging online retail.

 

Retail and wholesale trade is the single largest component of the services sector in terms of contributions to the Gross Domestic Product and at 14% it is the largest contributor after Agriculture. It employs about 7% of the total work force. The Retail Industry comprises Organized and unorganized sectors.

 

Organized retail which presently accounts for close to 8 percent of total market will increase its share to over 24% percent by 2016, offering huge potential for growth in coming years, says a study, ‘Indian Retailing-The way forward’.(ASSOCHAM, Press release).

 

India is perceived to be a lucrative destination for retail and with opening up of foreign direct investment imminent many multinational giants are eyeing India. There are many challenges in terms of infrastructure, supply chain efficiencies, cost structure and customer adaptability to the emerging retail formats. Indian companies are grappling with many challenges and experimenting with many formats in retail.

 

INTRODUCTION ABOUT THE STUDY:

This study attempts to understand the present scenario and the preparedness of domestic companies in consolidating their existing position to evolve a consumer aligned optimization frame work model. In this study, back end operations Grocery and Fruits and vegetables were analyzed using drivers such as sourcing, Procurement, Logistics for back end and revenue for consumer preference.

 

PURPOSE OF RESEARCH:

The research revealed that there are not many integrated optimization models, though there are studies done on different components of supply chain and retail by various authors. In this study endeavor is to understand the factors impacting back end supply chain drivers, using variables such as Stock keeping units, Cost of procurement, Weighted average gross margin, warehouse rent, sales quantity, sales value, manpower, processing and packing cost and secondary freight to build optimisation framework considering various interrelations.

 

LITERATURE REVIEW:

This study examine s the impact of interplay between shorter cycle times and shared point of sale information on the inventory management and cost efficiencies. Using an experimental design of ordering and shipping lag, this article explores the bullwhip effect, effect of shorter cycle on inventory costs and looks at possibility of optimality bench marks for decision maker using the sterman mental model (Joel, H et al, 2004).

 

A study of the food and grocery market channels was conducted and was found that most of the food and grocery products reach to consumers through the traditional markets which are unorganized. But the very fast changing trends in food and eating habits of consumers have contributed immensely to the growth of Western Retail format such as convenience stores, department stores, supermarkets, specialty stores and hypermarkets for various conspicuous reasons namely, demand, supply (Chetan et al., 2005).

 

This study elucidate the dynamics of customer relationship management in grocery and food buying and how the changing habits will emanate a shift from kiranas. The fast changing trends in lifestyles, food and eating habits of consumers have contributed largely to the growth and development of organised food and grocery retail formats in India. But, this sector is predominantly (99.2 percent) dominated by the traditional kirana (Ch. J. S. Prasad and A. R. Aryasri, 2008)

 

This study examines the viability and imperativeness of farm produce organised retail in the socio economic context. This paper looks into the antecedents of farm produce distribution and consumption in India, the evolving organized retailing and the ensuing movement against such moves in various states of India. (Venkatesh, 2008)

 

In this study focus was on the impact of product assortments, along with convenience, prices, and feature advertising, on consumers' grocery store choice decisions. It specifies a general structure for heterogeneity, and estimates store choice and category needs models simultaneously. Using household-level market basket data, the authors find that, in general, assortments are more important than retail prices in store choice decisions. They find that the number of brands offered in retail assortments has a positive effect on store choice for most households, while the number of stock keeping units per brand, sizes per brand, and proportion of stock keeping units that are unique to the store (a proxy for presence of private labels) have a negative effect on store choice for most households (Briesch et al., 2009).

 

This study conducted in Punjab gives insights on retail purchase behaviour in diversity of demographics and geographic locations. A study was conducted using sample survey method and questionnaire to garner insights on the diversity of purchase behavior amongst customers in food and grocery as per the demography and geography to evolve a retail business strategy for organised retail. Data analysis was done to identify major factors of concern in retail purchase decision making to find out retail purchase factor. Then Bartlett’s test of sphericity was conducted to reduce the data to simplify the interpretation of data and narrow down key factors Supply chain efficiencies starting from decision on the stock keeping units, procurement cost, Inventory Management and distribution has to be integrated and coordinated to have a robust back end (K. C. Mittal and Anupama Prashar, 2010).

 

A study was performed to discuss the core of supply chain management practices and identify five secondary constructs viz technology, supply chain speed, customer satisfaction, supply chain integration and four primary competitive advantage constructs viz inventory management, customer satisfaction, profitability and customer base identification (Rajwinder Singh et al., 2010).

 

This study concentrated on rolling horizon simulation models and performance analysis of partially and fully integrated sales and operations planning (S and OP) as opposed to conventional decoupled planning in a multi-site make-to-order (MTO) based manufacturing supply chain. Three simulation models are developed illustrating, respectively, the fully integrated S and OP model, procurement centrally; the partially integrated S and OP model, and the decoupled planning model. A solution procedure is provided for each model so that a more realistic planning process can be simulated. Performances of rolling horizon simulation models are evaluated against those of the fixed horizon deterministic models (Feng et al., 2010).

 

This research study was oriented towards allocation of production volumes among multiple manufacturing sites and distribution of products among distribution channels involving many variables and constraints. An integrated multi-product, multi-period, multi-site production-distribution planning subject to the production and distribution constraints, distribution system and local customers demand is considered in this paper. A mathematical model has been developed to solve the problem, aiming to decrease the costs of set up, production, inventory, distribution and transportation. (Safaei et al., 2010)

 

A study was performed to explore the dynamics of branding fruits and vegetables and retailing with respect to organised retail and can give qualitative insights. Indian economy has been witnessing significant changes in last few years in the retail sector. This paper is an attempt of authors to understand and study the present Indian retail industry's transition driven by organized retail sector with respect to fruits and vegetables in a detailed manner. This is basically an exploratory study to understand the retailing of vegetables and fruits in Indian context (Hemant and Manita, 2010)

 

A study was performed to analyse the interdependence of the marketing and supply chain in the organised retail scenario with specific focus on shelf facing, pricing and supply chain. Findings suggest that retailers and suppliers must work to integrate marketing activities and supply chain processes both within and across firms to most effectively serve the consumer at the retail shelf and increase market share (Waller et al., 2010).

 

A study was conducted to understand the importance of linking prime producers such as farmers to national and global markets through fresh food retail chain as this will ensure right price and high quality product (Singla et al., 2011)

 

This study deals with leverage of the enormously available customer data for aligning precious resources with customers' needs which makes it imperative for retail managers to deploy advanced tools and techniques for data analysis and generation of reports for effective decision-making. While a host of analytical processes and tools are available, a retailer needs to invest selectively and adapt to those applications that are proven to be successful, and resulted in substantial savings in terms of money, time and shelf space. This paper, apart from highlighting the relevance and efficacy of analytics for retail industry in India, also deals with a live study undertaken at Fresh Greens Bangalore, where Market Basket Analysis (MBA) and advanced demand forecasting techniques have been used for understanding the demand associations of different fruits and vegetables and fine-tuning their operations (Dasari, and Kurhekar, 2011)

 

This study examines how brand and stock-keeping-unit assortments affect category sales across a large number of categories over two time periods in which brand and/or stock keeping units assortments were changed in two retail outlets. It uses store range records and sales data from a retailer who primarily added or deleted entire brands in one outlet and primarily added or deleted SKUs within brands in a second outlet. Categories with a greater number of SKUs achieved relatively higher sales revenue (Tan et al., 2011).

 

OBJECTIVES OF THE STUDY:

       To identify, understand and analyze interrelations of key drivers of back end operations such as sourcing, procurement and logistics.

       To determine the relation between various factors influencing margin and weighted average margin.

       To create framework for supply chain optimization model aligned to consumer preference.

 

RESEARCH METHODOLOGY:

This study was conducted on two major organized retail companies operating in the convenience stores format in Bangalore catering to about seventy outlets and having distribution centres. The same was derived using the probabilistic multi stage sample design, on the population size of urban Retailers operating in the convenience stores format in the city of Bangalore. The research is an exploratory one. Primary data was collected through observation schedules using cost templates for key drivers to capture present costs. In- depth interviews with experts was conducted to collect data on supply chain and other Drivers. Secondary data was collected through, Journals, newspaper reports and articles, Government policy declarations, internet and other consultancy firms, Industry association reports. Data was analyzed using Multiple Linear regression as inferential model, Linear programming for simulation and optimisation.

 

HYPOTHESES :

Back end grocery significant influence of factors:

Hypothesis-1

H0: There is no significant influence of stock keeping units, sales total, sales quantity total, cost of procurement, warehouse cost and secondary freight on weighted average margin

H1 There is significant influence of stock keeping units, sales total, sales quantity total, cost of procurement, warehouse cost and secondary freight on weighted average margin

 

Back end fruits and vegetables significant influence of factors:

Hypothesis--2

H0: There is no significant influence of stock keeping units, cost of procurement, net sales value, operations cost on weighted average margin.

H1 There is no significant influence of stock keeping units, cost of procurement, net sales value, operations cost on weighted average margin.


 

 

DATA ANALYSIS AND DISCUSSION:

Following is the summarized result from analysis of:

Table 1:Model summary of regression model fit for back end grocery variables

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

1

.997a

.994

.994

.11111

a. Predictors: (Constant), Secondaryfreight1, stock keeping units, Cost of procurement Total, Sales Quantity Total, Warehousecost1, Sales Total

b. Dependent Variable: Weighted average contribution margin per unit

 

The table depicts that there is significant influence of various independent variables over dependent variable being weighted average contribution margin per unit as is depicted in the model summary which accounts for 99.7% of the variance. Adjusted R square at.994 establishes the overall significance of the regression model.


Back end grocery significance of relation between variables:

 

Table 2: Influence of backend grocery variables- secondary freight, stock keeping units, cost of procurement, sales quantity, warehouse cost and sales total on weighted average margin contribution per unit

ANOVAa

Model

Sum of Squares

Df

Mean Square

F

Sig.

1

Regression

3346.633

6

557.772

45180.671

.000b

Residual

21.123

1711

.012

 

 

Total

3367.756

1717

 

 

 

a. Dependent Variable: Weighted average contribution margin per unit

b. Predictors: (Constant), Secondary freight1, Stockkeeping units, Cost of procurement Total, Sales Quantity Total, Warehousecost1, Sales Total

 

As clearly depicted by anova there is significant linear relation between independent variables and dependent variables and hence rejects the null hypothesis.

 

Back end grocery significant predictors:

 

Table 3: Significant predictors of backend grocery- Stock keeping units, Sales Total, Cost of procurement Total and Secondary Freight

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

T

Sig.

B

Std. Error

Beta

1

(Constant)

-.023

.007

 

-3.492

.000

Stockkeepingunits

.007

.001

.011

5.392

.000

SalesTotal

1.587E-005

.000

8.368

306.717

.000

SalesQuantityTotal

-5.621E-007

.000

-.006

-1.526

.127

CostofprocurementTotal

-1.587E-005

.000

-7.519

-222.663

.000

warehousecost1

-.337

.261

-.028

-1.292

.197

Secondaryfreight1

-3.855

.249

-.237

-15.502

.000

a. Dependent Variable: Weighted average contribution margin per unit

 

The table shows that Stock keeping units, sales total, cost of procurement and secondary freight are significant and accordingly the equation of impact of change in any one unit on weighted average margin is derived below.

 

Weighted average contribution margin per unit = -.023 +.007(Stock keeping units) + Sales Total (1.587E-005) – (5.621E-007) (Sales Quantity Total) - (1.587E-005)(COGS Total) -.337 (Warehousehousecost1)- 3.855(Seondaryfreight1) + e1

 

Table 3.1: Variables excluded by the model on account of collinearity:

Excluded Variablesa

Model

Beta In

T

Sig.

Partial Correlation

Collinearity Statistics

Tolerance

1

Kgs

44.739b

.189

.850

.005

6.526E-011

Manpower1

.199b

.750

.453

.018

5.198E-005

Inventory1

.b

.

.

.

.000

Processing1

.b

.

.

.

.000

a. Dependent Variable: Weighted average contribution margin per unit

b. Predictors in the Model: (Constant), Secondaryfreight1, Category, COGS Total, Sales Quantity Total, Rent1, Sales Total

 

The above table 3.1 depicts the variables such as manpower, inventory and processing which has been excluded by the model on account of collinearity.

 

Following is the summarized result from analysis of:

 

Table Error! No text of specified style in document.:Model summary of Regression model fit for backend fruits and vegetables variables.

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

1

.991a

.982

.981

.00535

a. Predictors: (Constant), Operationscost1, Stock keeping units, cost of procurement, Net Sales value

b. Dependent Variable: Weighted average contribution margin per unit

 

The table depicts that there is significant influence of various independent variables over dependent variable weighted average contribution per unit as is depicted in the model summary which accounts for 98.2% of the variance. Adjusted R square at.981 establishes the overall significance of the regression model.

 

Back end fruit and vegetables significance of relation between variables

 

Table 5:Influence of backend fruits and vegetables variables- operations cost, stock keeping units, cost of procurement and net sales value on weighted average margin.

ANOVAa

Model

Sum of Squares

Df

Mean Square

F

Sig.

1

Regression

0.219

4

0.055

1909.731

.000b

Residual

0.004

140

0

 

 

Total

0.223

144

 

 

 

a. Dependent Variable: Weighted average contribution margin per unit

b. Predictors: (Constant), Operationscost1, Stock keeping units, Cost of procurement, Net Sales value

 

As clearly depicted by ANOVA (there is significant linear relation between independent variables and dependent variables and rejects the null hypothesis.

 

Back end fruits and vegetables significant predictors:

Table 6: Significant predictors of backend fruits and vegetables-constant, Cost of procurement, Net sales value and Operations cost.

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

T

Sig.

B

Std. Error

Beta

1

(Constant)

-0.003

0.001

 

-2.785

0.006

Stockkeepingunits

1.83E-05

0

0.001

0.093

0.926

Costofprocurement

-2.78E-06

0

-3.924

-32.378

.000

NetSalesvalue

2.80E-06

0

5.025

40.517

.000

Operationscost1

-6.30E-05

0

-0.347

-22.935

.000

Dependent Variable: Weighted average contribution margin per unit

 

Cost of procurement, net sales value and operations cost are significant and the equation of impact of change in any one unit on weighted average margin is derived below.

 

Weighted average contribution margin=

Constant(-.003)+ Cost of procurement (-2.780E-006)+ Net Sales(2.800E-006) + Operationscost1(-6.297E-005)+e1

Following is the summarized result from analysis of linear programming performed for various optimisation simulation:

 

Backend grocery simulation original mix

Table below depicts the original sales mix of critical category in grocery and staples which reflects the present preference of customers due to variety of reasons including price points, stock keeping units range, and quality. Taking this as base, further optimisation of margin through optimisation of sales and category mix is generated through linear program under different optimisation scenarios.

 

Table 7: Back end grocery original category mix

Category

Atta

Cereals

Dry Fruits

Edible Oil

Pulses

Salt and Sugar

Spices

Kgs

1262345

2239146

63143

938427

813226

794296

196013

Sales

36889742

75320021

24641168

92381152

66407362

23738822

44525110

COGS

26839106

59419413

17136205

84183932

46949400

19130903

31320071

Avg SP/kg

29.2

33.6

390.2

98.4

81.7

29.9

227.2

Avg COG/kg

21.3

26.5

271.4

89.7

57.7

24.1

159.8

Avg margin/kg

8

7.1

118.9

8.7

23.9

5.8

67.4

Rent

0.43

0.43

0.43

0.43

0.43

0.43

0.43

Manpower

0.28

0.28

0.28

0.15

0.28

0.28

0.28

Inventory

0.26

0.26

0.26

0.26

0.26

0.26

0.26

Processing

0.32

0.32

0.32

0.32

0.32

0.32

0.32

Secondary freight

0.35

0.35

0.35

0.35

0.35

0.35

0.35

Net margin/kg

6.3

5.5

117.2

7.2

22.3

4.2

65.7

Percentage of Total Sales

10.14%

20.70%

6.77%

25.39%

18.25%

6.52%

12.24%

Profit

68703523

Total Sales

363903378


 

The above table depicts the seven main categories viz., atta, cereals, dry fruits, edible oil,  pulses, salt and sugar and spices in the grocery and staples segment which comprises the sales composition of this business and reflects the customer preference at the front end and procurement in the back end i.e. a total of 1900 line items have been categorized thus. First row indicates the category sold in quantity, Second row depicts the value of sales and the third row the cost of items sold within the category. Percentage of sales depicts the percentage of contribution of each category to the total sales. Profit depicts the combined impact of margins due to the sales mix. Total sales is the sum total of all sales in the individual seven categories.

This original mix will be the base for simulating optimum mix scenarios.

 

Backend grocery simulation one on original base.

Keeping cost of goods sold as constraint the optimum mix sales revenue is generated. Contribution of each category in terms of percentage to the whole still remains closer to the original mix and therefore is viable as the present preference of customer is intact.

 

Table 8 :Back end grocery optimisation solution one

 Category

Atta

Cereals

Dry Fruits

Edible Oil

Pulses

Salt and Sugar

Spices

Sales

40578716

101682029

27105285

120095497

73048098

27299645

52094379

%of Total sales

9.18%

23.01%

6.13%

27.18%

16.53%

6.18%

11.79%

Profit

81054130

Sales

441903650


 

Simulation Solution one depicts that 21 % increase in overall sales as compared to original sales increases the profit by 17..97%.Further change in the sales mix i.e. reduction in contribution of atta and pulses and marginal increase in contribution of other categories also contribute to a higher margin as compared to original mix.

 

Backend grocery simulation two on original base.

In this there is substantial increase in many categories. This indicates that supply chain factors have to be improved particularly procurement cost as the cost of goods sold is to be kept at a particular point while the top line improves. However another aspect is that since the mix of many key categories is increasing, promotion and price strategies in the front end to be considered.

 

Table 9: Back end grocery optimisation solution two

Category

Atta

Cereals

Dry Fruits

Edible Oil

Pulses

Salt and Sugar

Spices

Sales

39840921

97916028

27105285

124714555

74376246

26587481

53430132

Percentage of Total Sales

11.37%

27.95%

7.74%

35.60%

21.23%

7.59%

15.25%

Profit

81271946

Sales

443970647

 

Simulation Solution two depicts that 22 % increase in overall sales as compared to original sales increases the profit by 18.29%.Further change in the sales mix i.e. increase in contribution of all the seven categories and pulses and substantial increase in contribution of edible oil also contribute to a higher margin as compared to original mix.

 

But the increase generated in edible oil has to be correlated with customer preference.

 

Backend grocery simulation three on original base.

This simulation generates ideal mix for all categories. But considering cost of goods sold as a constraint may not be appropriate as the cost cannot be kept at a constant level. However this is a good indicator probable ideal mix.


 

Table 10: Back end grocery optimisation solution three

Category

Atta

Cereals

Dry Fruits

Edible Oil

Pulses

Salt and Sugar

Spices

Sales

40578717

73646349

27105285

120095497

73048098

0

52094379

Percentage of Total Sales

10.49%

19.05%

7.01%

31.07%

18.90%

0.00%

13.48%

Profit

72701398

Sales

386568325

 

Simulation Solution three depicts that 6 % increase in overall sales as compared to original sales increases the profit by 5.18%.Further change in the sales mix i.e. increase in contribution of all the categories except salt and sugar increase the margin as compared to original mix. But zero sales generated in salt and sugar is not a viable proposition in correlation with customer preference.

 

Backend grocery simulation four on original base.

Table 11: Back end grocery optimisation solution four

 Category

Atta

Cereals

Dry Fruits

Edible Oil

Pulses

Salt and Sugar

Spices

Sales

42423203

72630021

26366050

129316928

77696614

25637928

50313375

Percentage of Total Sales

10.00%

17.11%

6.21%

30.47%

18.31%

6.04%

11.86%

Profit

77714442

Sales

424384119


 

Simulation Solution four depicts that 16.62 % increase in overall sales as compared to original sales increases the profit by 13.11%.Further change in the sales mix i.e. increase in contribution of all the categories except salt and sugar increase the margin as compared to original mix. This is a good indicator of ideal mix. But keeping cost of goods sold as a constraint may not be appropriate as the procurement cost can also increase.

 

Backend fruits and vegetables simulation original mix.

Table below depicts the original sales mix of critical category in fruits and vegetables which reflects the present preference of customers due to variety of reasons including price points, stock keeping units range, and quality. Taking this as base further optimisation of margin through optimisation of sales and category mix is generated through linear program under different optimisation scenarios.

 

Table 12: Back end fruits and vegetables original category mix

Category

Exotic

Fruits

Mango

OPT

Sprout

Vegetable

Net Sales Qty

2527.24

117438.4

3.79

84616.72

8158.54

92342.16

COGS

40435.78

1250799.26

56.07

1084777.1

54220

972542.76

Net Sales Value

50720

1618223.1

75.7

1413933.4

73197

1371244.97

Gross margin

10284.22

367423.84

19.63

329156.24

18977

398702.21

Gross Margin on Sales value in %

20.28

22.71

25.93

23.28

25.93

29.08

SP Per kg

20.07

13.78

20

16.71

8.97

14.85

Cogs Per Kg

16

10.65

14.81

12.82

6.65

10.53

GM Per kg

4.07

3.13

5.19

3.89

2.33

4.32

Manpower

0.21

0.21

0.21

0.21

0.21

0.21

Collection centre costs

0.34

0.34

0.34

0.34

0.34

0.34

Operations cost

0.62

0.62

0.62

0.62

0.62

0.62

Total

1.17

1.17

1.17

1.17

1.17

1.17

Net Margin

2.9

1.96

4.02

2.72

1.16

3.15

Net Margin percentage

14.45

14.21

20.08

16.28

12.89

21.2

Percentage of sales

1%

38%

0%

28%

3%

30%

Profits

767611.54

 

The above table depicts the six main categories viz exotic, fruits, onion, potato, tomato (OPT), sprout and vegetable in the fruits and Vegetable segment which comprises the sales composition of this business and reflects the customer preference at the front end and procurement in the back end ie a total of 145 line items have been categorized thus. First row indicates the category sold in quantity, Second row depicts the cost of item sold in each category and the third row the value of sales. Percentage of sales depicts the percentage of contribution of each category to the total sales. Profit depicts the combined impact of margins due to the sales mix.

This original mix will be the base for simulating optimum mix scenarios.

 

Backend fruits and vegetables simulation one on original base.

Keeping demand as constraint optimisation mix is generated keeping the same closer to present mix as it reflects the customer preference.

 

Table 13: Back end fruits and vegetables global optimisation solution one

Category

Exotic

Fruits

Mango

OPT

Sprout

Vegetable

Net Sales Value

52748.8

2265512

79.49

1908810

76856.85

1851181

% sales value

1%

40%

0%

28%

2%

30%

Profit

1042671

Original sales mix

1%

38%

0%

28%

3%

30%


Increase in sales is the only driver for optimisation and is suggested at 33% to increase profit by 35%. Original mix is retained in line with customer preference

 

Backend fruits and vegetables simulation two on original base.

Table 14 :Back end fruits and vegetables global optimisation solution two

Category

Exotic

Fruits

Mango

OPT

Sprout

Vegetable

Net Sales Value

51734.4

2216966

80.62

1866392

75392.91

1768906

%sales value

1%

40%

0%

28%

2%

30%

Profit

1011091

Original sales mix

1%

38%

0%

28%

3%

30%

 

Increase in sales is the only driver for optimisation and is suggested at 32.95% to increase profit by 31.72%. Original mix is retained in line with customer preference.

 

Backend fruits and vegetables simulation three on original base.

This simulation is heavily skewed towards one category that is vegetables and hence will not be a viable proposition. It would be imperative to look at other costs such as operations cost and dump.

 

Table 15: Back end fruits and vegetables global optimisation solution three

Category

Exotic

Fruits

Mango

OPT

Sprout

Vegetable

Net Sales Value

50973.60

2216965.65

81.00

1908810.04

76124.88

1810043.36

%sales value

1%

39.4%

0.001%

28%

2%

30%

Profit

1026700

Original sales mix

1%

38%

0%

28%

3%

30%

 


Increase in sales is the only driver for optimisation and is suggested at 32.99% to increase profit by 33.75%. Original mix is retained in line with customer preference

 

FINDINGS:

1.        The study indicates that there is significant linear relation between independent and dependent variables and stock keeping units, sales total, cost of procurement and secondary freight emerge as significant predictors for backend grocery.

2.        Similarly for backend fruits and vegetable cost of procurement, net sales value and operations cost emerge as significant predictors.

3.        Stock keeping units and category mix plays an important role in the back end grocery.

4.        Independent variables stock keeping units, cost of goods sold, secondary freight has significant inter play and establishes them as key drivers and factors in the back end.

5.        In case of fruits and vegetables sales revenue plays a major role. However operations cost also need to be monitored for better margin particularly dump cost.

6.        In the front end sales revenue is the key drivers to understand customer preference.

7.        In case of fruits and vegetables, it is substantially driven by changes in sales.

8.        Backend grocery optimisation solution suggests an increase of overall sales by 21% and thereby profit by 17.97% and seems to be the right mix as the original mix as per consumer preference is intact. However it requires marketing efforts to increase sales.

9.        Optimisation solution two for backend grocery ignores the edible oil in terms of correlating to customer preference and hence may not be viable.

10.     Optimisation solution three at increased sales of 6% is ideal, However this is viable only if the cost of goods is constant. Moreover it ignores important category like salt and sugar.

11.     Optimisation for backend fruits and vegetables can happen only on optimising sales and is the only driver of ideal mix.

12.     In the back end grocery and staples supply chain efficiencies in terms of cost of goods and secondary freight emerge as significant in addition to optimising category mix in line with customer preference.

13.     If the optimisation of back end grocery can be applied to improvement in share of grocery business in line with consumer preference as depicted by current sales the overall supermarket business can also improve the margin.

 

MANAGERIAL IMPLICATIONS :

The study highlights the imperativeness of evolving efficient supply chain models, backward and forward integration of supply chain and front end operations in organised retail. It also brings to the fore the need for creating separate modules for supply chain and front end operations which can be monitored separately and then integrate them into efficient value chain. This could help in enhancing the capability of Indian organised retail companies to gear up to counter stiff competition and sustain in the long run.

 

CONTRIBUTIONS TO THE BODY OF KNOWLEDGE :

Though this study is confined to only the convenience stores discount format in the organised retail, it has opened up a new vista of research into the subject. Further research can be conducted in creating integrated business model framework and expanding them to other formats of organised retail and can throw up newer ideas, innovations and efficient models. This research will hopefully initiate more exhaustive research which will have a cascading effect on the industry as a whole.

 

CONCLUSIONS:

India's retail market is expected to grow at 7% over the next 10 years, reaching a size of US$ 1.3 trillion by 2020. Traditional retail is expected to grow at 5% and reach a size of US$ 988 billion (76%), while organized retail is expected to grow at 25% and reach a size of US$ 312 billion by 2020.The overall conclusion which can be inferred from this study is that creation of a supply chain optimisation model framework aligned to consumer preference for the convenience stores format will not only give a direction for the strategy to be adopted but will also stream line the processes and systems which will enable Indian organised retail to capitalise on the growth of organised retail and equip them to adapt to differing marketing dynamics in view of impending foreign direct investment in multi brand and create sustainability

 

REFERENCES:

1.     Briesch, R.A., Chintangupta, P.K., and Fox, E.J. (2009). How does assortment affect grocery store choice, The Journal of Marketing Research, 46(2), 176-189.

2.     Balaji, Chetan, Tuli, Rajnish, and Srivastave, Nidhi, (2005)Retail management, Oxford university Press, new Delhi

3.     Dasari, S., and Kurhekar, A.S. (2011). Retail analytics using SAS: experience of fresh greens Pvt ltd, IUP Journal of Supply Chain Management, 8(1), 7-22. 

4.     Feng, Y., D'Amours, S., and Beauregard, R. (2010). Simulation and performance evaluation of partially and fully integrated sales and operations planning, International Journal of Production Research, 48(19), 5859-5883, 25p.

5.     Hemantkumar, B.P., and Manita, M. (2010). Retailing and branding of vegetables and fruits: An exploratory study, The Journal of Management Awareness, 13(2), 60-71.

6.     Mittal, K.C., and Prashar, A. (2010). A study of diversity in retail purchase behaviour in food and grocery Punjab, The Journal Of Business Perspective 14 (2) 46-58

7.     Prasasd, J.S., and Aryasari, A.R (2008) Study of customer relationship market practices in organised retail in food and grocery sector in India-an empirical analysis, The journal of business perspective 12(4)

8.     Rajwinder, S., Sandhu, S., Metri, B.A., and Rajinder, K. (2010). Relating organised retail supply chain management practices, competitive advantage and organisational performance, The Journal Of Business Perspective 14.(3), 173-190

9.     Safaei, A. S., Moattar Husseini, S.M., Farahani, R., Jolai, F., Ghodsypour, S. H. (2010). Integrated multi-site production-distribution planning in supply chain by hybrid modeling, International Journal of Production Research, 48 (140), 4043-4069, 27p,

10.  Singla, N., Singh, S., and Dhindsa, P. K.(2011) Linking small farmers to emerging agricultural marketing systems in India :The case study of a fresh food retail chain in Punjab, Agricultural Economics Research Review, 24 (1), 155-159, 5p

11.  Steckel, J.H., Gupta, S., and Banerji, A. (2004). Supply chain decision making: Will shorter cycle times and sharing of point of sale information necessarily help, The Journal of Management Science, 50(2), 458-464.

12.  Tan, Lay Peng; Cadeaux, Jack. (2011).Brand and stock-keeping-unit (SKU) assortments, assortment changes and category sales, International Review of Retail, Distribution and Consumer Research, 21(2), 161-185, 25p,

13.  Venkatesh, U. (2008). The case for organised agri retail: The Indian imperative, Journal of Services Research, 8 (1), 91-107, 17p,

14.  Waller, Matthew, A., Williams, Brent, D., Tangari, H.A., and Burton, S.(2010). Marketing at the retail shelf: An examination of moderating effects of logistics on SKU market share, Journal of the Academy of Marketing Science, 38 (1), 105-117, 13p


 

 

 

Received on 17.11.2016                Modified on 17.12.2016

Accepted on 26.12.2016          © A&V Publications all right reserved

Asian J. Management; 2017; 8(1):78-86.

DOI: 10.5958/2321-5763.2017.00012.9